relational database
Noun: A type of database that organizes data into one or more tables (relations) of rows and columns, with a unique key identifying each row. The core principle is that relationships between data points are established through these common keys, allowing data to be accessed and reassembled in various ways without reorganizing the database tables.
A relational database is used to store and manage structured data where the relationships between different entities are important. It is the foundation for many business applications due to its efficiency and clarity in modeling real-world relationships. - Example: The company's customer records, orders, and inventory are all managed within a single relational database. - Example: To generate the report, the software queries the relational database to join information from the Customers and Orders tables.
- Normalization: The process of structuring a relational database to reduce data redundancy and improve data integrity. Tables are organized to minimize duplication.
- Example: The database administrator applied normalization rules to the relational database design.
- ACID Properties: A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable transaction processing in a relational database.
- Example: Financial systems rely on the ACID properties of a relational database to ensure transaction accuracy.
- RDBMS (Relational Database Management System): The software used to create, manage, and query a relational database (e.g., MySQL, PostgreSQL, Oracle Database).
- Example: They chose an open-source RDBMS for the new project.
- Non-relational database (NoSQL): A database that does not use the traditional table-based relational model, often used for unstructured or semi-structured data.
- Example: For storing large volumes of social media posts, a non-relational database might be more suitable.
- Table-oriented database (less common)
- SQL database (common, though technically refers to databases using the SQL query language, which is predominantly used with the relational model)
- Primary Key: A unique identifier for a row in a table within a relational database.
- Example: The
customer_idfield is the primary key in theCustomerstable.
- Foreign Key: A field in one table that uniquely identifies a row in another table, establishing a link or relationship.
- Example: The
order_customer_idis a foreign key that relates each order to a specific customer.
- SQL (Structured Query Language): The standard language for communicating with and manipulating a relational database.
- Example: She wrote an SQL query to extract the needed data from the relational database.
- a database in which relations between information items are explicitly specified as accessible attributes
- in a relational database the data are organized as a number of differently sized tables